MySQL 8 for Big Data: Effective data processing with MySQL 8, Hadoop, NoSQL APIs, and other Big Data tools by Shabbir Challawala & Jaydip Lakhatariya & Chintan Mehta & Kandarp Patel

Author:Shabbir Challawala & Jaydip Lakhatariya & Chintan Mehta & Kandarp Patel [Challawala, Shabbir]
Language: eng
Format: azw3, pdf
Tags: COM021000 - COMPUTERS / Databases / General, COM062000 - COMPUTERS / Data Modeling and Design, COM021050 - COMPUTERS / Databases / Servers
Publisher: Packt Publishing
Published: 2017-10-20T04:00:00+00:00

Partitioning in MySQL 8

In general terms, partitioning is logically dividing anything into multiple subgroups so that each subgroup can be identified independently and can be combined into a single partition. Let's understand what partitioning means in terms of RDBMS.

What is partitioning?

Partitioning is generally used to divide data into multiple logical file groups for the purpose of performance, availability, and manageability. When dealing with big data, the normal tendency of data is to be in terms of billions of records. So to improve performance of the database, it is better to divide data among multiple file groups. These file groups can be on a single machine or shared across multiple machines and identified by a key. These file groups are known as partitioned data.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.